Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

You have to log in to post to discussions.

Related terms

ActionScript
Software; Graphic design software

ActionScript is the scripting language used to control ...

R, G, B color space
Software; Video editing

a) An additive color space with colorimetric coordinates ...

scrollbar
Software; Software engineering

A scrollbar is an object in a graphical user interface ...

OpenCart
Software; System software

Open Cart is a unique open source shopping cart system. It ...

cryptographic hash function
Software; Operating systems

An algorithm that takes any amount of data and transforms ...

Activate theme
Software; Web browser

THis is text. This must do.THis is text. This must do.THis ...

Creator

Featured blossaries

Tornadoes

Category: Science   1 20 Terms

Kitchen cabinets online

Category: Other   1 3 Terms

Office 365

Category: Technology   6 20 Terms

Fantasy Football

Category: Sports   13 22 Terms

Popular Pakistani actors

Category: Entertainment   1 7 Terms

Music Genre

Category: Education   2 10 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

Follow us on: